# -*- coding: utf-8 -*-
from __future__ import unicode_literals

from django.db import models, migrations
import django.db.models.deletion


class Migration(migrations.Migration):

    dependencies = [
    ]

    operations = [
        migrations.CreateModel(
            name='Division',
            fields=[
                ('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)),
                ('create_time', models.DateTimeField(auto_now_add=True, verbose_name='\u521b\u5efa\u65f6\u95f4', db_column=b'ctime')),
                ('create_by', models.CharField(max_length=64, verbose_name='\u521b\u5efa\u4eba(\u5de5\u53f7)', db_column=b'cperson', blank=True)),
                ('update_time', models.DateTimeField(db_column=b'utime', auto_now=True, auto_now_add=True, verbose_name='\u4fee\u6539\u65f6\u95f4')),
                ('update_by', models.CharField(max_length=64, verbose_name='\u4fee\u6539\u4eba(\u5de5\u53f7)', db_column=b'uperson', blank=True)),
                ('key', models.CharField(max_length=32, verbose_name='\u7f16\u7801', db_column=b'key')),
                ('val', models.CharField(max_length=64, verbose_name='\u503c', db_column=b'val')),
                ('short', models.CharField(max_length=16, verbose_name='\u7f29\u5199\u503c', db_column=b'short')),
            ],
            options={
                'db_table': 'division',
                'verbose_name': '\u4e8b\u4e1a\u90e8',
                'verbose_name_plural': '\u4e8b\u4e1a\u90e8',
            },
            bases=(models.Model,),
        ),
        migrations.CreateModel(
            name='EducationExp',
            fields=[
                ('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)),
                ('create_time', models.DateTimeField(auto_now_add=True, verbose_name='\u521b\u5efa\u65f6\u95f4', db_column=b'ctime')),
                ('create_by', models.CharField(max_length=64, verbose_name='\u521b\u5efa\u4eba(\u5de5\u53f7)', db_column=b'cperson', blank=True)),
                ('update_time', models.DateTimeField(db_column=b'utime', auto_now=True, auto_now_add=True, verbose_name='\u4fee\u6539\u65f6\u95f4')),
                ('update_by', models.CharField(max_length=64, verbose_name='\u4fee\u6539\u4eba(\u5de5\u53f7)', db_column=b'uperson', blank=True)),
                ('school', models.CharField(max_length=256, verbose_name='\u5b66\u6821', db_column=b'school', blank=True)),
                ('major', models.CharField(max_length=256, verbose_name='\u4e13\u4e1a', db_column=b'major', blank=True)),
                ('degree', models.CharField(max_length=128, verbose_name='\u5b66\u4f4d', db_column=b'degree', blank=True)),
                ('start_date', models.CharField(max_length=16, verbose_name='\u5f00\u59cb\u65e5\u671f', db_column=b'sdate', blank=True)),
                ('end_date', models.CharField(max_length=16, verbose_name='\u7ed3\u675f\u65e5\u671f', db_column=b'edate', blank=True)),
            ],
            options={
                'db_table': 'education_exp',
                'verbose_name': '\u6559\u80b2\u7ecf\u5386',
                'verbose_name_plural': '\u6559\u80b2\u7ecf\u5386',
            },
            bases=(models.Model,),
        ),
        migrations.CreateModel(
            name='MokiExp',
            fields=[
                ('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)),
                ('create_time', models.DateTimeField(auto_now_add=True, verbose_name='\u521b\u5efa\u65f6\u95f4', db_column=b'ctime')),
                ('create_by', models.CharField(max_length=64, verbose_name='\u521b\u5efa\u4eba(\u5de5\u53f7)', db_column=b'cperson', blank=True)),
                ('update_time', models.DateTimeField(db_column=b'utime', auto_now=True, auto_now_add=True, verbose_name='\u4fee\u6539\u65f6\u95f4')),
                ('update_by', models.CharField(max_length=64, verbose_name='\u4fee\u6539\u4eba(\u5de5\u53f7)', db_column=b'uperson', blank=True)),
                ('start_date', models.CharField(max_length=16, verbose_name='\u5f00\u59cb\u65e5\u671f', db_column=b'sdate', blank=True)),
                ('end_date', models.CharField(max_length=16, verbose_name='\u7ed3\u675f\u65e5\u671f', db_column=b'edate', blank=True)),
                ('job_nature', models.CharField(max_length=32, verbose_name='\u5458\u5de5\u5206\u7c7b', db_column=b'job_nature', blank=True)),
                ('job_level', models.CharField(max_length=32, verbose_name='\u804c\u4f4d\u7ea7\u522b', db_column=b'job_level', blank=True)),
                ('emp_type', models.CharField(max_length=32, verbose_name='\u5de5\u4f5c\u7c7b\u522b', db_column=b'emp_type', blank=True)),
                ('details_info', models.TextField(verbose_name='\u8be6\u7ec6\u4fe1\u606f', db_column=b'details', blank=True)),
                ('reason', models.CharField(max_length=256, verbose_name='\u804c\u4f4d\u53d8\u66f4\u539f\u56e0', db_column=b'reason', blank=True)),
            ],
            options={
                'db_table': 'moki_exp',
                'verbose_name': '\u6469\u5947\u7ecf\u5386',
                'verbose_name_plural': '\u6469\u5947\u7ecf\u5386',
            },
            bases=(models.Model,),
        ),
        migrations.CreateModel(
            name='PersonInfo',
            fields=[
                ('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)),
                ('create_time', models.DateTimeField(auto_now_add=True, verbose_name='\u521b\u5efa\u65f6\u95f4', db_column=b'ctime')),
                ('create_by', models.CharField(max_length=64, verbose_name='\u521b\u5efa\u4eba(\u5de5\u53f7)', db_column=b'cperson', blank=True)),
                ('update_time', models.DateTimeField(db_column=b'utime', auto_now=True, auto_now_add=True, verbose_name='\u4fee\u6539\u65f6\u95f4')),
                ('update_by', models.CharField(max_length=64, verbose_name='\u4fee\u6539\u4eba(\u5de5\u53f7)', db_column=b'uperson', blank=True)),
                ('gender', models.CharField(max_length=16, verbose_name='\u6027\u522b', db_column=b'gender')),
                ('age', models.CharField(max_length=8, verbose_name='\u5e74\u9f84', db_column=b'age')),
                ('born_date', models.CharField(max_length=16, verbose_name='\u51fa\u751f\u65e5\u671f', db_column=b'born_date')),
                ('nation', models.CharField(max_length=128, verbose_name='\u6c11\u65cf', db_column=b'nation')),
                ('nationality', models.CharField(max_length=128, verbose_name='\u56fd\u7c4d', db_column=b'nationality')),
                ('native_place', models.CharField(max_length=128, verbose_name='\u7c4d\u8d2f', db_column=b'native_place')),
                ('health', models.CharField(max_length=128, verbose_name='\u5065\u5eb7\u72b6\u51b5', db_column=b'health')),
                ('party', models.CharField(max_length=128, verbose_name='\u653f\u6cbb\u9762\u8c8c', db_column=b'party')),
                ('former_name', models.CharField(max_length=128, verbose_name='\u66fe\u7528\u540d', db_column=b'former_name')),
                ('formal_photo', models.CharField(max_length=256, verbose_name='\u8bc1\u4ef6\u7167', db_column=b'formal_photo')),
                ('life_photo', models.CharField(max_length=256, verbose_name='\u751f\u6d3b\u7167', db_column=b'life_photo')),
                ('social_ins_place', models.CharField(max_length=128, verbose_name='\u793e\u4fdd\u5173\u7cfb\u6240\u5728\u5730', db_column=b'siplace')),
                ('house_fund_place', models.CharField(max_length=128, verbose_name='\u516c\u79ef\u91d1\u7f34\u5b58\u5730', db_column=b'hfplace')),
                ('cert_type', models.CharField(max_length=128, verbose_name='\u8bc1\u4ef6\u7c7b\u578b', db_column=b'cert_type')),
                ('cert_number', models.CharField(max_length=32, verbose_name='\u8bc1\u4ef6\u53f7\u7801', db_column=b'cert_number')),
                ('cert_address', models.CharField(max_length=128, verbose_name='\u8bc1\u4ef6\u5730\u5740', db_column=b'cert_address')),
                ('cert_valid_date', models.CharField(max_length=16, verbose_name='\u8bc1\u4ef6\u6709\u6548\u65e5\u671f', db_column=b'cert_valid_date')),
                ('domicile_place', models.CharField(max_length=128, verbose_name='\u6237\u53e3\u6240\u5728\u5730', db_column=b'domicile_place')),
                ('domicile_type', models.CharField(max_length=32, verbose_name='\u6237\u7c4d\u7c7b\u578b', db_column=b'domicile_type')),
                ('tel', models.CharField(max_length=64, verbose_name='\u624b\u673a\u53f7\u7801', db_column=b'tel')),
                ('home_tel', models.CharField(max_length=64, verbose_name='\u5bb6\u5ead\u53f7\u7801', db_column=b'htel')),
                ('email', models.CharField(max_length=128, verbose_name='\u79c1\u4eba\u90ae\u7bb1', db_column=b'email')),
                ('qq', models.CharField(max_length=32, verbose_name='QQ\u53f7', db_column=b'qq')),
                ('weixin', models.CharField(max_length=32, verbose_name='\u5fae\u4fe1\u53f7', db_column=b'weixin')),
                ('live_address', models.CharField(max_length=256, verbose_name='\u73b0\u5bb6\u5ead\u4f4f\u5740', db_column=b'live_address')),
                ('emergency_contact', models.CharField(max_length=256, verbose_name='\u7d27\u6025\u8054\u7edc\u4eba', db_column=b'emergency_contact')),
                ('marriage', models.CharField(max_length=16, verbose_name='\u5a5a\u59fb\u72b6\u51b5', db_column=b'marriage')),
                ('fertility', models.CharField(max_length=16, verbose_name='\u751f\u80b2\u72b6\u51b5', db_column=b'fertility')),
                ('child', models.CharField(max_length=256, verbose_name='\u5c0f\u5b69\u60c5\u51b5', db_column=b'child')),
                ('family', models.TextField(verbose_name='\u4e3b\u8981\u5bb6\u5ead\u6210\u5458', db_column=b'family')),
                ('hobby', models.CharField(max_length=256, verbose_name='\u5174\u8da3\u7231\u597d', db_column=b'hobby')),
                ('height', models.CharField(max_length=16, verbose_name='\u8eab\u9ad8', db_column=b'height')),
                ('weight', models.CharField(max_length=16, verbose_name='\u4f53\u91cd', db_column=b'weight')),
                ('blood', models.CharField(max_length=16, verbose_name='\u8840\u578b', db_column=b'blood')),
                ('illness', models.TextField(verbose_name='\u91cd\u5927\u75be\u75c5\u624b\u672f\u53f2', db_column=b'illness')),
                ('criminal', models.TextField(verbose_name='\u72af\u7f6a\u53f2', db_column=b'criminal')),
            ],
            options={
                'db_table': 'person_info',
                'verbose_name': '\u4e2a\u4eba\u57fa\u672c\u4fe1\u606f',
                'verbose_name_plural': '\u4e2a\u4eba\u57fa\u672c\u4fe1\u606f',
            },
            bases=(models.Model,),
        ),
        migrations.CreateModel(
            name='PositionFamily',
            fields=[
                ('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)),
                ('create_time', models.DateTimeField(auto_now_add=True, verbose_name='\u521b\u5efa\u65f6\u95f4', db_column=b'ctime')),
                ('create_by', models.CharField(max_length=64, verbose_name='\u521b\u5efa\u4eba(\u5de5\u53f7)', db_column=b'cperson', blank=True)),
                ('update_time', models.DateTimeField(db_column=b'utime', auto_now=True, auto_now_add=True, verbose_name='\u4fee\u6539\u65f6\u95f4')),
                ('update_by', models.CharField(max_length=64, verbose_name='\u4fee\u6539\u4eba(\u5de5\u53f7)', db_column=b'uperson', blank=True)),
                ('key', models.CharField(max_length=32, verbose_name='\u7f16\u7801', db_column=b'key')),
                ('val', models.CharField(max_length=64, verbose_name='\u503c', db_column=b'val')),
            ],
            options={
                'db_table': 'position_family',
                'verbose_name': '\u804c\u4f4d\u96c6\u5408',
                'verbose_name_plural': '\u804c\u4f4d\u96c6\u5408',
            },
            bases=(models.Model,),
        ),
        migrations.CreateModel(
            name='PositionMap',
            fields=[
                ('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)),
                ('create_time', models.DateTimeField(auto_now_add=True, verbose_name='\u521b\u5efa\u65f6\u95f4', db_column=b'ctime')),
                ('create_by', models.CharField(max_length=64, verbose_name='\u521b\u5efa\u4eba(\u5de5\u53f7)', db_column=b'cperson', blank=True)),
                ('update_time', models.DateTimeField(db_column=b'utime', auto_now=True, auto_now_add=True, verbose_name='\u4fee\u6539\u65f6\u95f4')),
                ('update_by', models.CharField(max_length=64, verbose_name='\u4fee\u6539\u4eba(\u5de5\u53f7)', db_column=b'uperson', blank=True)),
                ('key', models.CharField(max_length=32, verbose_name='\u7f16\u7801', db_column=b'key')),
                ('val', models.CharField(max_length=64, verbose_name='\u503c', db_column=b'val')),
            ],
            options={
                'db_table': 'position_map',
                'verbose_name': '\u804c\u4f4d\u5b57\u5178',
                'verbose_name_plural': '\u804c\u4f4d\u5b57\u5178',
            },
            bases=(models.Model,),
        ),
        migrations.CreateModel(
            name='PositionSubFamily',
            fields=[
                ('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)),
                ('create_time', models.DateTimeField(auto_now_add=True, verbose_name='\u521b\u5efa\u65f6\u95f4', db_column=b'ctime')),
                ('create_by', models.CharField(max_length=64, verbose_name='\u521b\u5efa\u4eba(\u5de5\u53f7)', db_column=b'cperson', blank=True)),
                ('update_time', models.DateTimeField(db_column=b'utime', auto_now=True, auto_now_add=True, verbose_name='\u4fee\u6539\u65f6\u95f4')),
                ('update_by', models.CharField(max_length=64, verbose_name='\u4fee\u6539\u4eba(\u5de5\u53f7)', db_column=b'uperson', blank=True)),
                ('key', models.CharField(max_length=32, verbose_name='\u7f16\u7801', db_column=b'key')),
                ('val', models.CharField(max_length=64, verbose_name='\u503c', db_column=b'val')),
                ('parent', models.ForeignKey(db_column=b'parent', blank=True, to='staff.PositionFamily', null=True, verbose_name='\u4e0a\u7ea7\u5206\u7c7b')),
            ],
            options={
                'db_table': 'position_sub_family',
                'verbose_name': '\u804c\u4f4d\u5b50\u96c6',
                'verbose_name_plural': '\u804c\u4f4d\u5b50\u96c6',
            },
            bases=(models.Model,),
        ),
        migrations.CreateModel(
            name='ProductionTeam',
            fields=[
                ('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)),
                ('create_time', models.DateTimeField(auto_now_add=True, verbose_name='\u521b\u5efa\u65f6\u95f4', db_column=b'ctime')),
                ('create_by', models.CharField(max_length=64, verbose_name='\u521b\u5efa\u4eba(\u5de5\u53f7)', db_column=b'cperson', blank=True)),
                ('update_time', models.DateTimeField(db_column=b'utime', auto_now=True, auto_now_add=True, verbose_name='\u4fee\u6539\u65f6\u95f4')),
                ('update_by', models.CharField(max_length=64, verbose_name='\u4fee\u6539\u4eba(\u5de5\u53f7)', db_column=b'uperson', blank=True)),
                ('key', models.CharField(max_length=32, verbose_name='\u7f16\u7801', db_column=b'key')),
                ('val', models.CharField(max_length=64, verbose_name='\u503c', db_column=b'val')),
                ('short', models.CharField(max_length=16, verbose_name='\u7f29\u5199\u503c', db_column=b'short')),
                ('parent', models.ForeignKey(db_column=b'parent', blank=True, to='staff.Division', null=True, verbose_name='\u4e0a\u7ea7\u5206\u7c7b')),
            ],
            options={
                'db_table': 'production_team',
                'verbose_name': '\u751f\u4ea7\u56e2\u961f',
                'verbose_name_plural': '\u751f\u4ea7\u56e2\u961f',
            },
            bases=(models.Model,),
        ),
        migrations.CreateModel(
            name='StaffInfo',
            fields=[
                ('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)),
                ('create_time', models.DateTimeField(auto_now_add=True, verbose_name='\u521b\u5efa\u65f6\u95f4', db_column=b'ctime')),
                ('create_by', models.CharField(max_length=64, verbose_name='\u521b\u5efa\u4eba(\u5de5\u53f7)', db_column=b'cperson', blank=True)),
                ('update_time', models.DateTimeField(db_column=b'utime', auto_now=True, auto_now_add=True, verbose_name='\u4fee\u6539\u65f6\u95f4')),
                ('update_by', models.CharField(max_length=64, verbose_name='\u4fee\u6539\u4eba(\u5de5\u53f7)', db_column=b'uperson', blank=True)),
                ('cn_name', models.CharField(max_length=64, verbose_name='\u4e2d\u6587\u540d', db_column=b'cn_name', blank=True)),
                ('en_name', models.CharField(max_length=64, verbose_name='\u82f1\u6587\u540d', db_column=b'en_name', blank=True)),
                ('employee_id', models.CharField(max_length=64, verbose_name='\u5de5\u53f7', db_column=b'emp_id', blank=True)),
                ('qr_code', models.CharField(max_length=256, verbose_name='\u4e8c\u7ef4\u7801\u5730\u5740', db_column=b'qr_code', blank=True)),
                ('job_nature', models.CharField(max_length=32, verbose_name='\u5458\u5de5\u5206\u7c7b', db_column=b'job_nature', blank=True)),
                ('job_level', models.CharField(max_length=32, verbose_name='\u804c\u4f4d\u7ea7\u522b', db_column=b'job_level', blank=True)),
                ('emp_type', models.CharField(max_length=32, verbose_name='\u5de5\u4f5c\u7c7b\u522b', db_column=b'emp_type', blank=True)),
                ('work_email', models.CharField(max_length=256, verbose_name='\u90ae\u7bb1', db_column=b'wemail', blank=True)),
                ('is_on_board', models.BooleanField(default=True, verbose_name='\u662f\u5728\u5728\u804c', db_column=b'ioboard')),
                ('on_board_date', models.CharField(max_length=16, verbose_name='\u5165\u804c\u65e5\u671f', db_column=b'obdate', blank=True)),
                ('departure_date', models.CharField(max_length=16, verbose_name='\u79bb\u804c\u65e5\u671f', db_column=b'dtdate', blank=True)),
                ('position', models.ForeignKey(related_name='staff', on_delete=django.db.models.deletion.SET_NULL, db_column=b'postion', blank=True, to='staff.PositionMap', null=True, verbose_name='\u5f53\u524d\u804c\u4f4d')),
                ('production_team', models.ManyToManyField(to='staff.ProductionTeam', null=True, verbose_name='\u5f53\u524d\u751f\u4ea7\u56e2\u961f', blank=True)),
            ],
            options={
                'db_table': 'staff_info',
                'verbose_name': '\u804c\u5458\u4fe1\u606f',
                'verbose_name_plural': '\u804c\u5458\u4fe1\u606f',
            },
            bases=(models.Model,),
        ),
        migrations.CreateModel(
            name='WorkExp',
            fields=[
                ('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)),
                ('create_time', models.DateTimeField(auto_now_add=True, verbose_name='\u521b\u5efa\u65f6\u95f4', db_column=b'ctime')),
                ('create_by', models.CharField(max_length=64, verbose_name='\u521b\u5efa\u4eba(\u5de5\u53f7)', db_column=b'cperson', blank=True)),
                ('update_time', models.DateTimeField(db_column=b'utime', auto_now=True, auto_now_add=True, verbose_name='\u4fee\u6539\u65f6\u95f4')),
                ('update_by', models.CharField(max_length=64, verbose_name='\u4fee\u6539\u4eba(\u5de5\u53f7)', db_column=b'uperson', blank=True)),
                ('company', models.CharField(max_length=128, verbose_name='\u516c\u53f8\u540d', db_column=b'company', blank=True)),
                ('city', models.CharField(max_length=64, verbose_name='\u6240\u5728\u57ce\u5e02', db_column=b'city', blank=True)),
                ('start_end_date', models.CharField(max_length=128, verbose_name='\u8d77\u6b62\u65e5\u671f', db_column=b'sedate', blank=True)),
                ('department', models.CharField(max_length=128, verbose_name='\u804c\u4f4d(\u90e8\u95e8)', db_column=b'department', blank=True)),
                ('salary', models.CharField(max_length=128, verbose_name='\u85aa\u8d44\u6784\u6210', db_column=b'salary', blank=True)),
                ('is_departure', models.BooleanField(default=True, verbose_name='\u662f\u5426\u548c\u539f\u516c\u53f8\u89e3\u9664\u52b3\u52a8\u5173\u7cfb', db_column=b'is_departure')),
                ('is_lawsuit', models.BooleanField(default=True, verbose_name='\u662f\u5426\u548c\u539f\u516c\u53f8\u6709\u672a\u4e86\u8bc9\u8bbc', db_column=b'is_lawsuit')),
                ('staff', models.ForeignKey(db_column=b'staffinfo_id', verbose_name='\u804c\u5458\u4fe1\u606f', to='staff.StaffInfo')),
            ],
            options={
                'db_table': 'work_exp',
                'verbose_name': '\u5de5\u4f5c\u7ecf\u5386',
                'verbose_name_plural': '\u5de5\u4f5c\u7ecf\u5386',
            },
            bases=(models.Model,),
        ),
        migrations.AddField(
            model_name='positionmap',
            name='parent',
            field=models.ForeignKey(db_column=b'parent', blank=True, to='staff.PositionSubFamily', null=True, verbose_name='\u4e0a\u7ea7\u5206\u7c7b'),
            preserve_default=True,
        ),
        migrations.AddField(
            model_name='personinfo',
            name='staff_info',
            field=models.ForeignKey(db_column=b'staffinfo_id', verbose_name='\u804c\u5458\u4fe1\u606f', to='staff.StaffInfo'),
            preserve_default=True,
        ),
        migrations.AddField(
            model_name='mokiexp',
            name='staff',
            field=models.ForeignKey(db_column=b'staffinfo_id', verbose_name='\u804c\u5458\u4fe1\u606f', to='staff.StaffInfo'),
            preserve_default=True,
        ),
        migrations.AddField(
            model_name='educationexp',
            name='staff',
            field=models.ForeignKey(db_column=b'staffinfo_id', verbose_name='\u804c\u5458\u4fe1\u606f', to='staff.StaffInfo'),
            preserve_default=True,
        ),
        migrations.AddField(
            model_name='division',
            name='head',
            field=models.ForeignKey(on_delete=django.db.models.deletion.SET_NULL, db_column=b'head', blank=True, to='staff.StaffInfo', null=True, verbose_name='\u8d1f\u8d23\u4eba'),
            preserve_default=True,
        ),
    ]
